Job Description:
1. Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software
2. • Monitor DB2 on z/OS environment
3. • Create, modify and maintain the DB2 databases on z/OS environment
4. • Technical system support for DB2 sub systems, database tools and utilities
5. • Support DB2 business, end user and application requirements.
6. • Monitors DB2 Regions across life cycles, take necessary remedial action as required.
7. • Reorganize and update statistics in the DB2 System Catalog tables
8. • Perform regular housekeeping activities like administer the data server on which DB2 resides like monitoring disk space and the DB2 logs, Backups and protect the integrity of the data.
9. • Review all data models for technical accuracy. This includes the enforcement of all modeling and naming standards
10. • Perform all structural changes to DB2 databases
11. • Work with Buyer’s Security Administration to insure that proper security is in place for DB2 data
12. • Regularly review Automation and Dependency of systems tasks
13. • Manage and maintain data definitions for all prod and non-prod databases
14. • DB2 SQL performance tuning
15. • Perform Database backups, reorg and recovery
16. • DB2 Plan and Package management
17. • DB2 Database maintenance using utilities
18. • Assisting the developer teams in debugging DB2 related issues
